
CREATE TABLE Base_UserInfo
(
	User_ID VARCHAR2(50) NOT NULL PRIMARY KEY,
	User_Code VARCHAR2(50),
	User_Account VARCHAR2(50),
	User_Pwd VARCHAR2(50),
	User_Name VARCHAR2(50),
	User_Sex INT,
	Title VARCHAR2(50),
	Email VARCHAR2(50),
	Theme VARCHAR2(50),
	Question VARCHAR2(50),
	AnswerQuestion VARCHAR2(50),
	User_Remark VARCHAR2(3500),
	DeleteMark INT DEFAULT(1),
	CreateDate date default(sysdate),
	CreateUserId varchar2(50),
	CreateUserName varchar2(50),
	ModifyDate date,
	ModifyUserId varchar2(50),
	ModifyUserName varchar2(50)
);


/*


CREATE TABLE [dbo].[Base_UserInfo](
	[User_ID] [dbo].[Name(50)] NOT NULL,
	[User_Code] [dbo].[Name(50)] NULL,
	[User_Account] [dbo].[Name(50)] NULL,
	[User_Pwd] [dbo].[Name(50)] NULL,
	[User_Name] [dbo].[Name(50)] NULL,
	[User_Sex] [dbo].[ID] NULL,
	[Title] [dbo].[Name(50)] NULL,
	[Email] [dbo].[Name(20)] NULL,
	[Theme] [dbo].[Name(50)] NULL,
	[Question] [dbo].[Name(50)] NULL,
	[AnswerQuestion] [dbo].[Name(50)] NULL,
	[DeleteMark] [dbo].[ID] NULL,
	[CreateDate] [Date] NULL,
	[CreateUserId] [dbo].[Name(50)] NULL,
	[CreateUserName] [dbo].[Name(50)] NULL,
	[ModifyDate] [Date] NULL,
	[ModifyUserId] [dbo].[Name(50)] NULL,
	[ModifyUserName] [dbo].[Name(50)] NULL,
	[User_Remark] [dbo].[Name(Max)] NULL,
 CONSTRAINT [PK_BASE_USERINFO] PRIMARY KEY NONCLUSTERED 
(
	[User_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_ID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Code'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户账户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Account'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Pwd'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别 1：男、0：女' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Sex'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'Title'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'Email'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统样式选择' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'Theme'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码提示问题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'Question'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码提示答案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'AnswerQuestion'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记 1：正常，2：锁定，0：删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'DeleteMark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'CreateUserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'CreateUserName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'ModifyUserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'ModifyUserName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo', @level2type=N'COLUMN',@level2name=N'User_Remark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户帐户表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_UserInfo'
GO

ALTER TABLE [dbo].[Base_UserInfo] ADD  CONSTRAINT [DF_Base_UserInfo_DeleteMark]  DEFAULT ((1)) FOR [DeleteMark]
GO

ALTER TABLE [dbo].[Base_UserInfo] ADD  CONSTRAINT [DF_Base_UserInfo_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]
GO

*/